<html>
<head>
	<title>webnote sqlite database install</title>
</head>

<body>
	<pre> 
<?php
    if ($db = new SQLite3('webnote.db3'))
	{
		$q = $db->query('CREATE TABLE IF NOT EXISTS notes (noteid INTEGER PRIMARY KEY ASC, timestamp INT DEFAULT CURRENT_TIMESTAMP, title STRING, content TEXT)');
		if ($q === false)
		{
			die('Could not create table');
		}
		else
			echo 'Create table successful';	
	}
	else
		die("Couldn't open database");
?>
	</pre>
</body>
</html>